package sg.edu.nus.iss.phoenix.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @author Vipul Sanghrajka
 *
 */
public class DBConnection {

	
	private Connection connection;
	private String strConnection;
	
	public Connection getDBConnection() throws SQLException{
		String dbUrl = "jdbc:mysql://localhost:3306/prms";
		connection = DriverManager.getConnection(dbUrl,"root","password");
		return connection;
	}
	
	public void closeConnection(Connection con){
		try{
			con.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
}
